Blog - data modeling

1 Introduction to SQL History of SQL, importance of SQL, Relational databases.

2 SQL Database schema What is a DB schema and which one we will use in this course.

3 SQL Basic syntax Case sensitivity, statements, comments...

4 SQL Data types Common datatypes used in SQL databases

5 SELECT statement What is 'SELECT' statement and how to use it?

6 Constraining Queries with Conditions Leveraging Operators and Logical Keywords to Filter Result Sets

7 Filtering and sorting SQL results Leveraging Operators and Logical Keywords to Filter Result Sets

8 Querying multiple tables with joins Mastering Data Relationships: The Art of SQL Joins Across Multiple Tables

9 Grouping Data and Aggregate Functions GROUP BY and HAVING clauses and aggregate functions like COUNT, SUM, AVG..

10 Subqueries and common table expressions Subqueries, Correlated subqueries and common table expressions (CTEs)

11 SQL functions and expressions Built-in SQL functions: string functions, date functions, and more

12 Insert, Update and Delete INSERT, UPDATE, DELETE statements

13 Create tables How to create a table in SQL, data types and constraints

14 Alter tables Add/rename/drop columns and foreign keys with ALTER TABLE statement

15 Drop tables How to drop tables from the database

16 Indexes and performance tuning What are indexes and how to tune them

Database Design